{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os,ogr\n",
    "path = os.getcwd()+\"/shp/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import gdal\n",
    "gdal.SetConfigOption(\"GDAL_FILENAME_IS_UTF8\", \"YES\")\n",
    "gdal.SetConfigOption(\"SHAPE_ENCODING\", \"CP936\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "pnt = path + \"北京_point.shp\"\n",
    "driver = ogr.GetDriverByName('ESRI Shapefile')\n",
    "dataSource = driver.Open(pnt, 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "layer = dataSource.GetLayerByIndex(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "lyd = layer.GetLayerDefn()\n",
    "fields = [lyd.GetFieldDefn(i).GetName() for i in range(lyd.GetFieldCount())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['NAME',\n",
       " 'LAYER',\n",
       " 'MARINE',\n",
       " 'RegionName',\n",
       " 'DataLevel',\n",
       " 'MP_TYPE',\n",
       " 'Phone',\n",
       " 'StreetDesc',\n",
       " 'HighwayIdx',\n",
       " 'ZipIdx',\n",
       " 'City']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fields"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "渡外.云居\n"
     ]
    }
   ],
   "source": [
    "print(layer.GetFeature(0).GetField(\"NAME\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "北京大学\n",
      "北京大学\n"
     ]
    }
   ],
   "source": [
    "layer.SetAttributeFilter(\"NAME = '北京大学'\")\n",
    "feDict = []\n",
    "for feature in layer:\n",
    "    name = feature.GetField(\"NAME\")\n",
    "    print(\"{0}\".format(name))\n",
    "    f = {}\n",
    "    for field in fields:\n",
    "        f[field] = feature.GetField(field)\n",
    "    geo = feature.GetGeometryRef()\n",
    "    f[\"Shape\"] = geo.ExportToWkt()\n",
    "    feDict.append(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>DataLevel</th>\n",
       "      <th>HighwayIdx</th>\n",
       "      <th>LAYER</th>\n",
       "      <th>MARINE</th>\n",
       "      <th>MP_TYPE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>Phone</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Shape</th>\n",
       "      <th>StreetDesc</th>\n",
       "      <th>ZipIdx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30353 39.99041 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学</td>\n",
       "      <td>01062752114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.29852 39.99324 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   City  DataLevel HighwayIdx                  LAYER MARINE MP_TYPE  NAME  \\\n",
       "0  None          1       None  Unknown Point Feature      N  0x2900  北京大学   \n",
       "1  None          1       None                 School      N  0x2C05  北京大学   \n",
       "\n",
       "         Phone RegionName                         Shape StreetDesc ZipIdx  \n",
       "0         None        北京市  POINT (116.30353 39.99041 0)       None   None  \n",
       "1  01062752114        北京市  POINT (116.29852 39.99324 0)       None   None  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(feDict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "北京大学软件与微电子学院\n",
      "北京大学法律自考部\n",
      "北京大学第三医院第二门诊部\n",
      "北京大学化学与分子工程学院应用化学系应用化学研究所\n",
      "北京大学技物楼\n",
      "北京大学遥感与地理信息系统研究所\n",
      "北京大学数字中国研究院\n",
      "北京大学重离子物理研究所\n",
      "北京大学幼儿园\n",
      "北京大学工学院\n",
      "北京大学微电子学研究院\n",
      "北京大学物理学院\n",
      "北京大学东侧门\n",
      "北京大学印刷厂\n",
      "北京大学出版社\n",
      "北京大学音像出版社\n",
      "北京大学中关园\n",
      "北京大学教育基金会\n",
      "北京大学学生科协\n",
      "北京大学体育馆\n",
      "北京大学中国教育与人力资源研究中心\n",
      "北京大学企业与教育研究中心\n",
      "北京大学东门\n",
      "北京大学中国古文献研究中心\n",
      "北京大学化学应用开发研究所\n",
      "北京大学化学与分子工程学院\n",
      "北京大学-富士通信息科学技术联合研究中心\n",
      "北京大学香港中文大学智能工程联合研究中心\n",
      "北京大学TCL信息技术研究中心\n",
      "北京大学微电子学研究院\n",
      "北京大学言语听觉研究中心\n",
      "北京大学东南门\n",
      "北京大学中国地震局现代地震科学技术研究中心\n",
      "北京大学石油与天然气研究中心\n",
      "北京大学中国持续发展研究中心\n",
      "北京大学经济法研究所\n",
      "北京大学外国哲学研究所\n",
      "北京大学教育经济研究所\n",
      "北京大学政治发展与政府管理研究所\n",
      "北京大学高能物理研究中心\n",
      "北京大学汉语语言学研究中心\n",
      "北京大学邓小平理论研究中心\n",
      "北京大学图书馆\n",
      "北京大学北大德力科技公司\n",
      "北京大学北大德力科化学公司\n",
      "北京大学二十世纪中国文化研究中心\n",
      "北京大学希腊研究中心\n",
      "北京大学东方文学研究中心\n",
      "北京大学欧美文学研究中心\n",
      "北京大学文化产业研究院\n",
      "北京大学中国人口健康与发展研究中心\n",
      "北京大学人学研究中心\n",
      "北京大学\n",
      "北京大学医院\n",
      "北京大学美学与美育研究中心\n",
      "北京大学正大国际中心\n",
      "北京大学四一七公寓\n",
      "北京大学物理化学研究所\n",
      "北京大学震旦古代文明研究中心\n",
      "北京大学中国考古学研究中心\n",
      "北京大学机动车专用门\n",
      "北京大学\n",
      "北京大学幼儿园\n",
      "北京大学档案馆\n",
      "北京大学校史馆\n",
      "北京大学赛克勒考古与艺术博物馆\n",
      "北京大学大熊猫及野生动物保护研究中心\n",
      "北京大学中国考古学研究中心\n",
      "北京大学建筑学研究中心\n",
      "北京大学中国经济研究中心\n",
      "北京大学中国古代史研究中心\n",
      "北京大学应用文理学院\n",
      "北京大学应用文理学院\n",
      "北京大学羽毛球馆\n",
      "北京大学南门\n",
      "北京大学第三医院中央党校院区\n",
      "北京大学燕北园\n",
      "北京大学燕北园南门\n",
      "北京大学外国语学院自考部\n",
      "北京大学口腔医学研究所\n",
      "北京大学邮电所邮政储蓄\n",
      "北京大学邮电所\n",
      "北京大学口腔医院第三门诊部\n",
      "北京大学医学部东南门\n",
      "北京大学医学部会议中心\n",
      "北京大学第三医院\n",
      "北京大学眼科中心林护眼科医院\n",
      "北京大学第三医院门诊部\n",
      "北京大学精神卫生研究所\n",
      "北京大学运动医学研究所\n",
      "北京大学医学部\n",
      "北京大学医学部西南门\n",
      "北京大学眼科中心眼科研究所\n",
      "北京大学医学部南门\n",
      "北京大学医学部\n",
      "北京大学临床药理研究所\n",
      "北京大学中国药物依赖性研究所\n",
      "北京大学医学部体育馆\n",
      "北京大学医学部体育场\n",
      "北京大学第一医院综合门诊部\n",
      "北京大学红楼\n",
      "北京大学第一医院\n",
      "北京大学第一医院停车场\n",
      "北京大学口腔医院门诊部\n",
      "北京大学第一医院第二两门住院部\n",
      "北京大学医院人民眼科中心\n",
      "北京大学医院儿童眼病中心\n",
      "北京大学第一医院妇儿门诊\n",
      "北京大学人民医院\n",
      "北京大学人民医院\n",
      "北京大学医院第三住院部\n",
      "北京大学生就业之家\n",
      "北京大学临床肿瘤学院\n",
      "北京大学临床肿瘤学院\n",
      "北京大学航天临床医学院\n",
      "北京大学继续教育学院\n",
      "北京大学继续教育学院\n"
     ]
    }
   ],
   "source": [
    "layer.SetAttributeFilter(\"NAME LIKE '北京大学%'\")\n",
    "feDict = []\n",
    "for feature in layer:\n",
    "    name = feature.GetField(\"NAME\")\n",
    "    print(\"{0}\".format(name))\n",
    "    f = {}\n",
    "    for field in fields:\n",
    "        f[field] = feature.GetField(field)\n",
    "    geo = feature.GetGeometryRef()\n",
    "    f[\"Shape\"] = geo.ExportToWkt()\n",
    "    feDict.append(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>DataLevel</th>\n",
       "      <th>HighwayIdx</th>\n",
       "      <th>LAYER</th>\n",
       "      <th>MARINE</th>\n",
       "      <th>MP_TYPE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>Phone</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Shape</th>\n",
       "      <th>StreetDesc</th>\n",
       "      <th>ZipIdx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学软件与微电子学院</td>\n",
       "      <td>01061273672</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35087 39.75768 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京大学法律自考部</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.29576 40.09117 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学第三医院第二门诊部</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33786 40.05638 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学化学与分子工程学院应用化学系应用化学研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32066 39.98878 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学技物楼</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31993 39.98832 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学遥感与地理信息系统研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30622 39.99181 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学数字中国研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30622 39.99181 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学重离子物理研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31372 39.99124 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学幼儿园</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31389 39.99438 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学工学院</td>\n",
       "      <td>01062751812</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31218 39.99266 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学微电子学研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31033 39.99189 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学物理学院</td>\n",
       "      <td>01062751732</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31033 39.99103 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学东侧门</td>\n",
       "      <td>01062752114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30721 39.9916 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学印刷厂</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31329 39.99124 0)</td>\n",
       "      <td>成府路203</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学出版社</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31244 39.9912 0)</td>\n",
       "      <td>成府路205</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学音像出版社</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31244 39.9912 0)</td>\n",
       "      <td>成府路205</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学中关园</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31226 39.99064 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学教育基金会</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30434 39.99533 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学学生科协</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30567 39.99117 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>北京大学体育馆</td>\n",
       "      <td>01062753697</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30948 39.98808 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国教育与人力资源研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30554 39.98842 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学企业与教育研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30554 39.98842 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学东门</td>\n",
       "      <td>01062752114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30922 39.99078 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国古文献研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30442 39.98962 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学化学应用开发研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31064 39.98983 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学化学与分子工程学院</td>\n",
       "      <td>01062751710</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31068 39.99056 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学-富士通信息科学技术联合研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学香港中文大学智能工程联合研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学TCL信息技术研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学微电子学研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3000</td>\n",
       "      <td>北京大学第三医院门诊部</td>\n",
       "      <td>01062388404</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35268 39.98036 0)</td>\n",
       "      <td>花园北路49号</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学精神卫生研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35114 39.98036 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学运动医学研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35329 39.98049 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学医学部</td>\n",
       "      <td>01062091114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.34789 39.98276 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学医学部西南门</td>\n",
       "      <td>01082801114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3556 39.98048 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学眼科中心眼科研究所</td>\n",
       "      <td>01062017691</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35496 39.98048 0)</td>\n",
       "      <td>花园北路49号</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学医学部南门</td>\n",
       "      <td>01082801114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35209 39.98027 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学医学部</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35097 39.98233 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学临床药理研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3517 39.98504 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国药物依赖性研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3517 39.98504 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>北京大学医学部体育馆</td>\n",
       "      <td>01082802428</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35496 39.98391 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>北京大学医学部体育场</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35368 39.98391 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学第一医院综合门诊部</td>\n",
       "      <td>01066551122</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.40002 39.9441 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Landmark</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C04</td>\n",
       "      <td>北京大学红楼</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.39921 39.92298 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学第一医院</td>\n",
       "      <td>01066551122</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3739 39.93042 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F0B</td>\n",
       "      <td>北京大学第一医院停车场</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3739 39.93042 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3000</td>\n",
       "      <td>北京大学口腔医院门诊部</td>\n",
       "      <td>01066176293</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.37241 39.92239 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学第一医院第二两门住院部</td>\n",
       "      <td>01066551122</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.37104 39.92746 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学医院人民眼科中心</td>\n",
       "      <td>01066130031</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35993 39.92258 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学医院儿童眼病中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.35993 39.92258 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学第一医院妇儿门诊</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.37553 39.92145 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学人民医院</td>\n",
       "      <td>01088326666</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.34819 39.93617 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学人民医院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.34819 39.93578 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Hospital</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3002</td>\n",
       "      <td>北京大学医院第三住院部</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.34246 39.93626 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京大学生就业之家</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31146 39.92661 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学临床肿瘤学院</td>\n",
       "      <td>01088122458</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.2843 39.92216 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学临床肿瘤学院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.28374 39.92199 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学航天临床医学院</td>\n",
       "      <td>01088200925</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.24656 39.91532 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学继续教育学院</td>\n",
       "      <td>01062647149</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.187 40.24367 0)</td>\n",
       "      <td>西山口村</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学继续教育学院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.18489 40.24582 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>117 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     City  DataLevel HighwayIdx                  LAYER MARINE MP_TYPE  \\\n",
       "0    None          1       None                 School      N  0x2C05   \n",
       "1    None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "2    None          1       None               Hospital      N  0x3002   \n",
       "3    None          1       None                 School      N  0x2C05   \n",
       "4    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "5    None          1       None                 School      N  0x2C05   \n",
       "6    None          1       None                 School      N  0x2C05   \n",
       "7    None          1       None                 School      N  0x2C05   \n",
       "8    None          1       None                 School      N  0x2C05   \n",
       "9    None          1       None                 School      N  0x2C05   \n",
       "10   None          1       None                 School      N  0x2C05   \n",
       "11   None          1       None                 School      N  0x2C05   \n",
       "12   None          1       None                 School      N  0x2C05   \n",
       "13   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "14   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "15   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "16   None          1       None  Unknown Point Feature      N  0x3005   \n",
       "17   None          1       None  Unknown Point Feature      N  0x3005   \n",
       "18   None          1       None  Unknown Point Feature      N  0x3005   \n",
       "19   None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "20   None          1       None                 School      N  0x2C05   \n",
       "21   None          1       None                 School      N  0x2C05   \n",
       "22   None          1       None                 School      N  0x2C05   \n",
       "23   None          1       None                 School      N  0x2C05   \n",
       "24   None          1       None                 School      N  0x2C05   \n",
       "25   None          1       None                 School      N  0x2C05   \n",
       "26   None          1       None                 School      N  0x2C05   \n",
       "27   None          1       None                 School      N  0x2C05   \n",
       "28   None          1       None                 School      N  0x2C05   \n",
       "29   None          1       None                 School      N  0x2C05   \n",
       "..    ...        ...        ...                    ...    ...     ...   \n",
       "87   None          1       None  Unknown Point Feature      N  0x3000   \n",
       "88   None          1       None                 School      N  0x2C05   \n",
       "89   None          1       None                 School      N  0x2C05   \n",
       "90   None          1       None                 School      N  0x2C05   \n",
       "91   None          1       None                 School      N  0x2C05   \n",
       "92   None          1       None                 School      N  0x2C05   \n",
       "93   None          1       None                 School      N  0x2C05   \n",
       "94   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "95   None          1       None                 School      N  0x2C05   \n",
       "96   None          1       None                 School      N  0x2C05   \n",
       "97   None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "98   None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "99   None          1       None               Hospital      N  0x3002   \n",
       "100  None          1       None               Landmark      N  0x2C04   \n",
       "101  None          1       None               Hospital      N  0x3002   \n",
       "102  None          1       None  Unknown Point Feature      N  0x2F0B   \n",
       "103  None          1       None  Unknown Point Feature      N  0x3000   \n",
       "104  None          1       None               Hospital      N  0x3002   \n",
       "105  None          1       None               Hospital      N  0x3002   \n",
       "106  None          1       None               Hospital      N  0x3002   \n",
       "107  None          1       None               Hospital      N  0x3002   \n",
       "108  None          1       None               Hospital      N  0x3002   \n",
       "109  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "110  None          1       None               Hospital      N  0x3002   \n",
       "111  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "112  None          1       None                 School      N  0x2C05   \n",
       "113  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "114  None          1       None                 School      N  0x2C05   \n",
       "115  None          1       None                 School      N  0x2C05   \n",
       "116  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "\n",
       "                          NAME        Phone RegionName  \\\n",
       "0                 北京大学软件与微电子学院  01061273672        北京市   \n",
       "1                    北京大学法律自考部         None        北京市   \n",
       "2                北京大学第三医院第二门诊部         None        北京市   \n",
       "3    北京大学化学与分子工程学院应用化学系应用化学研究所         None        北京市   \n",
       "4                      北京大学技物楼         None        北京市   \n",
       "5             北京大学遥感与地理信息系统研究所         None        北京市   \n",
       "6                  北京大学数字中国研究院         None        北京市   \n",
       "7                 北京大学重离子物理研究所         None        北京市   \n",
       "8                      北京大学幼儿园         None        北京市   \n",
       "9                      北京大学工学院  01062751812        北京市   \n",
       "10                 北京大学微电子学研究院         None        北京市   \n",
       "11                    北京大学物理学院  01062751732        北京市   \n",
       "12                     北京大学东侧门  01062752114        北京市   \n",
       "13                     北京大学印刷厂         None        北京市   \n",
       "14                     北京大学出版社         None        北京市   \n",
       "15                   北京大学音像出版社         None        北京市   \n",
       "16                     北京大学中关园         None        北京市   \n",
       "17                   北京大学教育基金会         None        北京市   \n",
       "18                    北京大学学生科协         None        北京市   \n",
       "19                     北京大学体育馆  01062753697        北京市   \n",
       "20           北京大学中国教育与人力资源研究中心         None        北京市   \n",
       "21               北京大学企业与教育研究中心         None        北京市   \n",
       "22                      北京大学东门  01062752114        北京市   \n",
       "23               北京大学中国古文献研究中心         None        北京市   \n",
       "24               北京大学化学应用开发研究所         None        北京市   \n",
       "25               北京大学化学与分子工程学院  01062751710        北京市   \n",
       "26        北京大学-富士通信息科学技术联合研究中心         None        北京市   \n",
       "27        北京大学香港中文大学智能工程联合研究中心         None        北京市   \n",
       "28             北京大学TCL信息技术研究中心         None        北京市   \n",
       "29                 北京大学微电子学研究院         None        北京市   \n",
       "..                         ...          ...        ...   \n",
       "87                 北京大学第三医院门诊部  01062388404        北京市   \n",
       "88                 北京大学精神卫生研究所         None        北京市   \n",
       "89                 北京大学运动医学研究所         None        北京市   \n",
       "90                     北京大学医学部  01062091114        北京市   \n",
       "91                  北京大学医学部西南门  01082801114        北京市   \n",
       "92               北京大学眼科中心眼科研究所  01062017691        北京市   \n",
       "93                   北京大学医学部南门  01082801114        北京市   \n",
       "94                     北京大学医学部         None        北京市   \n",
       "95                 北京大学临床药理研究所         None        北京市   \n",
       "96              北京大学中国药物依赖性研究所         None        北京市   \n",
       "97                  北京大学医学部体育馆  01082802428        北京市   \n",
       "98                  北京大学医学部体育场         None        北京市   \n",
       "99               北京大学第一医院综合门诊部  01066551122        北京市   \n",
       "100                     北京大学红楼         None        北京市   \n",
       "101                   北京大学第一医院  01066551122        北京市   \n",
       "102                北京大学第一医院停车场         None        北京市   \n",
       "103                北京大学口腔医院门诊部  01066176293        北京市   \n",
       "104            北京大学第一医院第二两门住院部  01066551122        北京市   \n",
       "105               北京大学医院人民眼科中心  01066130031        北京市   \n",
       "106               北京大学医院儿童眼病中心         None        北京市   \n",
       "107               北京大学第一医院妇儿门诊         None        北京市   \n",
       "108                   北京大学人民医院  01088326666        北京市   \n",
       "109                   北京大学人民医院         None        北京市   \n",
       "110                北京大学医院第三住院部         None        北京市   \n",
       "111                  北京大学生就业之家         None        北京市   \n",
       "112                 北京大学临床肿瘤学院  01088122458        北京市   \n",
       "113                 北京大学临床肿瘤学院         None        北京市   \n",
       "114                北京大学航天临床医学院  01088200925        北京市   \n",
       "115                 北京大学继续教育学院  01062647149        北京市   \n",
       "116                 北京大学继续教育学院         None        北京市   \n",
       "\n",
       "                            Shape StreetDesc ZipIdx  \n",
       "0    POINT (116.35087 39.75768 0)       None   None  \n",
       "1    POINT (116.29576 40.09117 0)       None   None  \n",
       "2    POINT (116.33786 40.05638 0)       None   None  \n",
       "3    POINT (116.32066 39.98878 0)       None   None  \n",
       "4    POINT (116.31993 39.98832 0)       None   None  \n",
       "5    POINT (116.30622 39.99181 0)       None   None  \n",
       "6    POINT (116.30622 39.99181 0)       None   None  \n",
       "7    POINT (116.31372 39.99124 0)       None   None  \n",
       "8    POINT (116.31389 39.99438 0)       None   None  \n",
       "9    POINT (116.31218 39.99266 0)       None   None  \n",
       "10   POINT (116.31033 39.99189 0)       None   None  \n",
       "11   POINT (116.31033 39.99103 0)       None   None  \n",
       "12    POINT (116.30721 39.9916 0)       None   None  \n",
       "13   POINT (116.31329 39.99124 0)     成府路203   None  \n",
       "14    POINT (116.31244 39.9912 0)     成府路205   None  \n",
       "15    POINT (116.31244 39.9912 0)     成府路205   None  \n",
       "16   POINT (116.31226 39.99064 0)       None   None  \n",
       "17   POINT (116.30434 39.99533 0)       None   None  \n",
       "18   POINT (116.30567 39.99117 0)       None   None  \n",
       "19   POINT (116.30948 39.98808 0)       None   None  \n",
       "20   POINT (116.30554 39.98842 0)       None   None  \n",
       "21   POINT (116.30554 39.98842 0)       None   None  \n",
       "22   POINT (116.30922 39.99078 0)       None   None  \n",
       "23   POINT (116.30442 39.98962 0)       None   None  \n",
       "24   POINT (116.31064 39.98983 0)       None   None  \n",
       "25   POINT (116.31068 39.99056 0)       None   None  \n",
       "26    POINT (116.3088 39.98898 0)       None   None  \n",
       "27    POINT (116.3088 39.98898 0)       None   None  \n",
       "28    POINT (116.3088 39.98898 0)       None   None  \n",
       "29    POINT (116.3088 39.98898 0)       None   None  \n",
       "..                            ...        ...    ...  \n",
       "87   POINT (116.35268 39.98036 0)    花园北路49号   None  \n",
       "88   POINT (116.35114 39.98036 0)       None   None  \n",
       "89   POINT (116.35329 39.98049 0)       None   None  \n",
       "90   POINT (116.34789 39.98276 0)       None   None  \n",
       "91    POINT (116.3556 39.98048 0)       None   None  \n",
       "92   POINT (116.35496 39.98048 0)    花园北路49号   None  \n",
       "93   POINT (116.35209 39.98027 0)       None   None  \n",
       "94   POINT (116.35097 39.98233 0)       None   None  \n",
       "95    POINT (116.3517 39.98504 0)       None   None  \n",
       "96    POINT (116.3517 39.98504 0)       None   None  \n",
       "97   POINT (116.35496 39.98391 0)       None   None  \n",
       "98   POINT (116.35368 39.98391 0)       None   None  \n",
       "99    POINT (116.40002 39.9441 0)       None   None  \n",
       "100  POINT (116.39921 39.92298 0)       None   None  \n",
       "101   POINT (116.3739 39.93042 0)       None   None  \n",
       "102   POINT (116.3739 39.93042 0)       None   None  \n",
       "103  POINT (116.37241 39.92239 0)       None   None  \n",
       "104  POINT (116.37104 39.92746 0)       None   None  \n",
       "105  POINT (116.35993 39.92258 0)       None   None  \n",
       "106  POINT (116.35993 39.92258 0)       None   None  \n",
       "107  POINT (116.37553 39.92145 0)       None   None  \n",
       "108  POINT (116.34819 39.93617 0)       None   None  \n",
       "109  POINT (116.34819 39.93578 0)       None   None  \n",
       "110  POINT (116.34246 39.93626 0)       None   None  \n",
       "111  POINT (116.31146 39.92661 0)       None   None  \n",
       "112   POINT (116.2843 39.92216 0)       None   None  \n",
       "113  POINT (116.28374 39.92199 0)       None   None  \n",
       "114  POINT (116.24656 39.91532 0)       None   None  \n",
       "115    POINT (116.187 40.24367 0)       西山口村   None  \n",
       "116  POINT (116.18489 40.24582 0)       None   None  \n",
       "\n",
       "[117 rows x 12 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(feDict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "中国信息大学\n",
      "中国信息大学\n",
      "现代管理大学\n",
      "现代管理大学\n",
      "北京民族大学\n",
      "北京民族大学\n",
      "北京现代管理大学\n",
      "北京现代管理大学\n",
      "北京明园大学\n",
      "北京明园大学\n",
      "北京工商大学\n",
      "北京工商大学\n",
      "大兴老年大学\n",
      "北京联合大学\n",
      "北京医药集团职工大学\n",
      "北京工业大学\n",
      "北京工业大学\n",
      "崇文职工大学\n",
      "崇文职工大学\n",
      "北京市东城区职工大学\n",
      "北京城市建设职工大学\n",
      "首都经济贸易大学\n",
      "首都经济贸易大学\n",
      "北京汽车工业总公司职工大学\n",
      "中国传媒大学\n",
      "中国传媒大学\n",
      "北京人文大学\n",
      "北京人文大学\n",
      "北京市顺义区老年大学\n",
      "顺义区老年大学\n",
      "国航大学\n",
      "国航大学\n",
      "国际青年研修大学\n",
      "国际青年研修大学\n",
      "北京京华医科大学\n",
      "首都联合职工大学\n",
      "首都联合职工大学\n",
      "北京京华医科大学\n",
      "北京自修大学\n",
      "北京自修大学\n",
      "北京体育大学\n",
      "北京体育大学\n",
      "清华大学\n",
      "清华大学\n",
      "北京大学\n",
      "北京大学\n",
      "北京外国语大学\n",
      "中央民族大学\n",
      "北京外国语大学\n",
      "北京理工大学\n",
      "北京理工大学\n",
      "中央民族大学\n",
      "中央财经大学\n",
      "中央财经大学\n",
      "中国政法大学\n",
      "中国政法大学\n",
      "中国人民大学\n",
      "中国人民大学\n",
      "北京广播电视大学\n",
      "北京交通大学\n",
      "北京交通大学\n",
      "北京邮电大学\n",
      "北京邮电大学\n",
      "北京师范大学\n",
      "北京京教老年大学\n",
      "北京京教老年大学\n",
      "北京师范大学\n",
      "北京航空航天大学\n",
      "北京市海淀区职工大学\n",
      "北京航空航天大学\n",
      "北京语言大学\n",
      "中国矿业大学\n",
      "北京语言大学\n",
      "中国矿业大学\n",
      "北京科技大学\n",
      "中国地质大学\n",
      "海淀职工大学\n",
      "中国地质大学\n",
      "北京科技大学\n",
      "北京林业大学\n",
      "北京林业大学\n",
      "北京联合大学\n",
      "北京联合大学\n",
      "北京中医药大学\n",
      "北京中医药大学\n",
      "北京化工大学\n",
      "北京化工大学\n",
      "北京市朝阳区职工大学\n",
      "对外经济贸易大学\n",
      "对外经济贸易大学\n",
      "东城老年大学\n",
      "北京老年大学\n",
      "北京市房地产职工大学\n",
      "房地产职工大学\n",
      "中国协和医科大学\n",
      "协和医科大学\n",
      "商务部老年大学\n",
      "西城经济科学大学\n",
      "北京市西城经济科学大学\n",
      "西城经济科学大学\n",
      "北京市立信会计职工大学\n",
      "中央广播电视大学\n",
      "北京市总工会职工大学\n",
      "北京林业大学夜大学\n",
      "北京宣武红旗业余大学\n",
      "宣武红旗业余大学\n",
      "首都医科大学\n",
      "首都医科大学\n",
      "北京市总工会职工大学\n",
      "北京市房地产职工大学\n",
      "北京市丰台区老年大学\n",
      "北京市丰台区职工大学\n",
      "丰台区老年大学\n",
      "宣武区红旗业余大学\n",
      "宣武区红旗业余大学\n",
      "中国人民公安大学\n",
      "中国人民公安大学\n",
      "首都师范大学\n",
      "首都师范大学\n",
      "北方工业大学\n",
      "北方工业大学\n",
      "北京市石景山区业余大学\n",
      "北京应用科技大学\n",
      "北京应用科技大学\n",
      "北京建设大学\n",
      "北京建设大学\n",
      "中国航天三院老年大学\n",
      "北京应用技术大学\n",
      "北京东方大学\n",
      "北京东方大学\n",
      "北京吉利大学\n",
      "北京吉利大学\n",
      "北京航空航天大学\n",
      "北京航空航天大学\n",
      "北京市怀柔区老干部大学\n",
      "延庆电视大学\n",
      "延庆电视大学\n",
      "大厂县老年大学\n"
     ]
    }
   ],
   "source": [
    "layer.SetAttributeFilter(\"NAME LIKE '%大学'\")\n",
    "feDict = []\n",
    "for feature in layer:\n",
    "    name = feature.GetField(\"NAME\")\n",
    "    print(\"{0}\".format(name))\n",
    "    f = {}\n",
    "    for field in fields:\n",
    "        f[field] = feature.GetField(field)\n",
    "    geo = feature.GetGeometryRef()\n",
    "    f[\"Shape\"] = geo.ExportToWkt()\n",
    "    feDict.append(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>DataLevel</th>\n",
       "      <th>HighwayIdx</th>\n",
       "      <th>LAYER</th>\n",
       "      <th>MARINE</th>\n",
       "      <th>MP_TYPE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>Phone</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Shape</th>\n",
       "      <th>StreetDesc</th>\n",
       "      <th>ZipIdx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>中国信息大学</td>\n",
       "      <td>01081303008</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.0602 39.68678 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>中国信息大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.06067 39.68674 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>现代管理大学</td>\n",
       "      <td>01089351545</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.04858 39.63008 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>现代管理大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.04799 39.63004 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京民族大学</td>\n",
       "      <td>01060318128</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.08678 39.66513 0)</td>\n",
       "      <td>交道</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京民族大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.09014 39.66505 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京现代管理大学</td>\n",
       "      <td>01068910339</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.10919 39.72843 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京现代管理大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.10919 39.72818 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京明园大学</td>\n",
       "      <td>01080331653</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.12167 39.70918 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京明园大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.12192 39.70905 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京工商大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.16395 39.71903 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京工商大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.16382 39.71762 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>大兴老年大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33576 39.72282 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京联合大学</td>\n",
       "      <td>None</td>\n",
       "      <td>河北省</td>\n",
       "      <td>POINT (116.75466 39.59988 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京医药集团职工大学</td>\n",
       "      <td>01087613211</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.42715 39.84426 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京工业大学</td>\n",
       "      <td>01065010161</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.47363 39.87029 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京工业大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.47363 39.87256 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>崇文职工大学</td>\n",
       "      <td>01067143047</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.43596 39.88414 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>崇文职工大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.43596 39.8844 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京市东城区职工大学</td>\n",
       "      <td>01065537004</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.43217 39.92825 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京城市建设职工大学</td>\n",
       "      <td>01085982066</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.46711 39.92691 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>首都经济贸易大学</td>\n",
       "      <td>01065976600</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.47 39.91404 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>首都经济贸易大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.47017 39.9131 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京汽车工业总公司职工大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.47246 39.92495 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>中国传媒大学</td>\n",
       "      <td>01065779145</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.55035 39.90855 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>中国传媒大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.55026 39.90945 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京人文大学</td>\n",
       "      <td>01061160073</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.6704 39.93137 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京人文大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.67086 39.93196 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京市顺义区老年大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.66686 40.1113 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>顺义区老年大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.66686 40.11164 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京市总工会职工大学</td>\n",
       "      <td>01063521133</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.37138 39.87743 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京市房地产职工大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.40498 39.85806 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京市丰台区老年大学</td>\n",
       "      <td>01063822961</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.28058 39.86054 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京市丰台区职工大学</td>\n",
       "      <td>01083820578</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.28105 39.86629 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>丰台区老年大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.28024 39.86088 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>宣武区红旗业余大学</td>\n",
       "      <td>01063265086</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33047 39.88032 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>宣武区红旗业余大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33073 39.88028 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>中国人民公安大学</td>\n",
       "      <td>01083903114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33162 39.901 0)</td>\n",
       "      <td>木樨地南里1号</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>中国人民公安大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33134 39.90032 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>首都师范大学</td>\n",
       "      <td>01068465056</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30362 39.92921 0)</td>\n",
       "      <td>西三环北路105号</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>首都师范大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3005 39.92938 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北方工业大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.20209 39.92761 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北方工业大学</td>\n",
       "      <td>01068872812</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.20084 39.92671 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京市石景山区业余大学</td>\n",
       "      <td>01068874596</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.19333 39.91584 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京应用科技大学</td>\n",
       "      <td>01088201763</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.24326 39.91403 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京应用科技大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.24296 39.91403 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京建设大学</td>\n",
       "      <td>01062734834</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.24026 39.85541 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京建设大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.24014 39.85567 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>中国航天三院老年大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.15409 39.80492 0)</td>\n",
       "      <td>云岗</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京应用技术大学</td>\n",
       "      <td>01081700923</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.21825 39.95054 0)</td>\n",
       "      <td>杏石口路98号</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京东方大学</td>\n",
       "      <td>01062465120</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.23706 40.04916 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京东方大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.23766 40.04929 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京吉利大学</td>\n",
       "      <td>01060758446</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.1586 40.17317 0)</td>\n",
       "      <td>马池口镇</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京吉利大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.15878 40.17531 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京航空航天大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.26104 40.15563 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京航空航天大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.26113 40.15541 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京市怀柔区老干部大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.62395 40.31605 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>延庆电视大学</td>\n",
       "      <td>01069173115</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (115.96877 40.46938 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>延庆电视大学</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (115.96882 40.46899 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>大厂县老年大学</td>\n",
       "      <td>None</td>\n",
       "      <td>河北省</td>\n",
       "      <td>POINT (116.98233 39.89191 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>138 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     City  DataLevel HighwayIdx                  LAYER MARINE MP_TYPE  \\\n",
       "0    None          1       None                 School      N  0x2C05   \n",
       "1    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "2    None          1       None                 School      N  0x2C05   \n",
       "3    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "4    None          1       None                 School      N  0x2C05   \n",
       "5    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "6    None          1       None                 School      N  0x2C05   \n",
       "7    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "8    None          1       None                 School      N  0x2C05   \n",
       "9    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "10   None          1       None                 School      N  0x2C05   \n",
       "11   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "12   None          1       None                 School      N  0x2C05   \n",
       "13   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "14   None          1       None                 School      N  0x2C05   \n",
       "15   None          1       None                 School      N  0x2C05   \n",
       "16   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "17   None          1       None                 School      N  0x2C05   \n",
       "18   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "19   None          1       None                 School      N  0x2C05   \n",
       "20   None          1       None                 School      N  0x2C05   \n",
       "21   None          1       None                 School      N  0x2C05   \n",
       "22   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "23   None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "24   None          1       None                 School      N  0x2C05   \n",
       "25   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "26   None          1       None                 School      N  0x2C05   \n",
       "27   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "28   None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "29   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "..    ...        ...        ...                    ...    ...     ...   \n",
       "108  None          1       None                 School      N  0x2C05   \n",
       "109  None          1       None                 School      N  0x2C05   \n",
       "110  None          1       None                 School      N  0x2C05   \n",
       "111  None          1       None                 School      N  0x2C05   \n",
       "112  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "113  None          1       None                 School      N  0x2C05   \n",
       "114  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "115  None          1       None                 School      N  0x2C05   \n",
       "116  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "117  None          1       None                 School      N  0x2C05   \n",
       "118  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "119  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "120  None          1       None                 School      N  0x2C05   \n",
       "121  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "122  None          1       None                 School      N  0x2C05   \n",
       "123  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "124  None          1       None                 School      N  0x2C05   \n",
       "125  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "126  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "127  None          1       None                 School      N  0x2C05   \n",
       "128  None          1       None                 School      N  0x2C05   \n",
       "129  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "130  None          1       None                 School      N  0x2C05   \n",
       "131  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "132  None          1       None                 School      N  0x2C05   \n",
       "133  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "134  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "135  None          1       None                 School      N  0x2C05   \n",
       "136  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "137  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "\n",
       "              NAME        Phone RegionName                         Shape  \\\n",
       "0           中国信息大学  01081303008        北京市   POINT (116.0602 39.68678 0)   \n",
       "1           中国信息大学         None        北京市  POINT (116.06067 39.68674 0)   \n",
       "2           现代管理大学  01089351545        北京市  POINT (116.04858 39.63008 0)   \n",
       "3           现代管理大学         None        北京市  POINT (116.04799 39.63004 0)   \n",
       "4           北京民族大学  01060318128        北京市  POINT (116.08678 39.66513 0)   \n",
       "5           北京民族大学         None        北京市  POINT (116.09014 39.66505 0)   \n",
       "6         北京现代管理大学  01068910339        北京市  POINT (116.10919 39.72843 0)   \n",
       "7         北京现代管理大学         None        北京市  POINT (116.10919 39.72818 0)   \n",
       "8           北京明园大学  01080331653        北京市  POINT (116.12167 39.70918 0)   \n",
       "9           北京明园大学         None        北京市  POINT (116.12192 39.70905 0)   \n",
       "10          北京工商大学         None        北京市  POINT (116.16395 39.71903 0)   \n",
       "11          北京工商大学         None        北京市  POINT (116.16382 39.71762 0)   \n",
       "12          大兴老年大学         None        北京市  POINT (116.33576 39.72282 0)   \n",
       "13          北京联合大学         None        河北省  POINT (116.75466 39.59988 0)   \n",
       "14      北京医药集团职工大学  01087613211        北京市  POINT (116.42715 39.84426 0)   \n",
       "15          北京工业大学  01065010161        北京市  POINT (116.47363 39.87029 0)   \n",
       "16          北京工业大学         None        北京市  POINT (116.47363 39.87256 0)   \n",
       "17          崇文职工大学  01067143047        北京市  POINT (116.43596 39.88414 0)   \n",
       "18          崇文职工大学         None        北京市   POINT (116.43596 39.8844 0)   \n",
       "19      北京市东城区职工大学  01065537004        北京市  POINT (116.43217 39.92825 0)   \n",
       "20      北京城市建设职工大学  01085982066        北京市  POINT (116.46711 39.92691 0)   \n",
       "21        首都经济贸易大学  01065976600        北京市     POINT (116.47 39.91404 0)   \n",
       "22        首都经济贸易大学         None        北京市   POINT (116.47017 39.9131 0)   \n",
       "23   北京汽车工业总公司职工大学         None        北京市  POINT (116.47246 39.92495 0)   \n",
       "24          中国传媒大学  01065779145        北京市  POINT (116.55035 39.90855 0)   \n",
       "25          中国传媒大学         None        北京市  POINT (116.55026 39.90945 0)   \n",
       "26          北京人文大学  01061160073        北京市   POINT (116.6704 39.93137 0)   \n",
       "27          北京人文大学         None        北京市  POINT (116.67086 39.93196 0)   \n",
       "28      北京市顺义区老年大学         None        北京市   POINT (116.66686 40.1113 0)   \n",
       "29         顺义区老年大学         None        北京市  POINT (116.66686 40.11164 0)   \n",
       "..             ...          ...        ...                           ...   \n",
       "108     北京市总工会职工大学  01063521133        北京市  POINT (116.37138 39.87743 0)   \n",
       "109     北京市房地产职工大学         None        北京市  POINT (116.40498 39.85806 0)   \n",
       "110     北京市丰台区老年大学  01063822961        北京市  POINT (116.28058 39.86054 0)   \n",
       "111     北京市丰台区职工大学  01083820578        北京市  POINT (116.28105 39.86629 0)   \n",
       "112        丰台区老年大学         None        北京市  POINT (116.28024 39.86088 0)   \n",
       "113      宣武区红旗业余大学  01063265086        北京市  POINT (116.33047 39.88032 0)   \n",
       "114      宣武区红旗业余大学         None        北京市  POINT (116.33073 39.88028 0)   \n",
       "115       中国人民公安大学  01083903114        北京市    POINT (116.33162 39.901 0)   \n",
       "116       中国人民公安大学         None        北京市  POINT (116.33134 39.90032 0)   \n",
       "117         首都师范大学  01068465056        北京市  POINT (116.30362 39.92921 0)   \n",
       "118         首都师范大学         None        北京市   POINT (116.3005 39.92938 0)   \n",
       "119         北方工业大学         None        北京市  POINT (116.20209 39.92761 0)   \n",
       "120         北方工业大学  01068872812        北京市  POINT (116.20084 39.92671 0)   \n",
       "121    北京市石景山区业余大学  01068874596        北京市  POINT (116.19333 39.91584 0)   \n",
       "122       北京应用科技大学  01088201763        北京市  POINT (116.24326 39.91403 0)   \n",
       "123       北京应用科技大学         None        北京市  POINT (116.24296 39.91403 0)   \n",
       "124         北京建设大学  01062734834        北京市  POINT (116.24026 39.85541 0)   \n",
       "125         北京建设大学         None        北京市  POINT (116.24014 39.85567 0)   \n",
       "126     中国航天三院老年大学         None        北京市  POINT (116.15409 39.80492 0)   \n",
       "127       北京应用技术大学  01081700923        北京市  POINT (116.21825 39.95054 0)   \n",
       "128         北京东方大学  01062465120        北京市  POINT (116.23706 40.04916 0)   \n",
       "129         北京东方大学         None        北京市  POINT (116.23766 40.04929 0)   \n",
       "130         北京吉利大学  01060758446        北京市   POINT (116.1586 40.17317 0)   \n",
       "131         北京吉利大学         None        北京市  POINT (116.15878 40.17531 0)   \n",
       "132       北京航空航天大学         None        北京市  POINT (116.26104 40.15563 0)   \n",
       "133       北京航空航天大学         None        北京市  POINT (116.26113 40.15541 0)   \n",
       "134    北京市怀柔区老干部大学         None        北京市  POINT (116.62395 40.31605 0)   \n",
       "135         延庆电视大学  01069173115        北京市  POINT (115.96877 40.46938 0)   \n",
       "136         延庆电视大学         None        北京市  POINT (115.96882 40.46899 0)   \n",
       "137        大厂县老年大学         None        河北省  POINT (116.98233 39.89191 0)   \n",
       "\n",
       "    StreetDesc ZipIdx  \n",
       "0         None   None  \n",
       "1         None   None  \n",
       "2         None   None  \n",
       "3         None   None  \n",
       "4           交道   None  \n",
       "5         None   None  \n",
       "6         None   None  \n",
       "7         None   None  \n",
       "8         None   None  \n",
       "9         None   None  \n",
       "10        None   None  \n",
       "11        None   None  \n",
       "12        None   None  \n",
       "13        None   None  \n",
       "14        None   None  \n",
       "15        None   None  \n",
       "16        None   None  \n",
       "17        None   None  \n",
       "18        None   None  \n",
       "19        None   None  \n",
       "20        None   None  \n",
       "21        None   None  \n",
       "22        None   None  \n",
       "23        None   None  \n",
       "24        None   None  \n",
       "25        None   None  \n",
       "26        None   None  \n",
       "27        None   None  \n",
       "28        None   None  \n",
       "29        None   None  \n",
       "..         ...    ...  \n",
       "108       None   None  \n",
       "109       None   None  \n",
       "110       None   None  \n",
       "111       None   None  \n",
       "112       None   None  \n",
       "113       None   None  \n",
       "114       None   None  \n",
       "115    木樨地南里1号   None  \n",
       "116       None   None  \n",
       "117  西三环北路105号   None  \n",
       "118       None   None  \n",
       "119       None   None  \n",
       "120       None   None  \n",
       "121       None   None  \n",
       "122       None   None  \n",
       "123       None   None  \n",
       "124       None   None  \n",
       "125       None   None  \n",
       "126         云岗   None  \n",
       "127    杏石口路98号   None  \n",
       "128       None   None  \n",
       "129       None   None  \n",
       "130       马池口镇   None  \n",
       "131       None   None  \n",
       "132       None   None  \n",
       "133       None   None  \n",
       "134       None   None  \n",
       "135       None   None  \n",
       "136       None   None  \n",
       "137       None   None  \n",
       "\n",
       "[138 rows x 12 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(feDict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "gdal.SetConfigOption(\"GDAL_FILENAME_IS_UTF8\", \"NO\")\n",
    "gdal.SetConfigOption(\"SHAPE_ENCODING\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "cn =  os.getcwd() + \"/china/cn.shp\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'D:\\\\workspace\\\\DevWork\\\\PyExample\\\\exam4/china/cn.shp'"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver = ogr.GetDriverByName('ESRI Shapefile')\n",
    "dataSource = driver.Open(cn, 0)\n",
    "layer = dataSource.GetLayerByIndex(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "lyd = layer.GetLayerDefn()\n",
    "fields = [lyd.GetFieldDefn(i).GetName() for i in range(lyd.GetFieldCount())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['FIRST_NAME',\n",
       " 'Code',\n",
       " 'AREA',\n",
       " 'Pop_2009',\n",
       " 'Pop_2005',\n",
       " 'Pop_2000',\n",
       " 'Pop_1999',\n",
       " 'Pop_1995',\n",
       " 'Pop_1990',\n",
       " 'Pop_Birth_',\n",
       " 'Pop_Death_',\n",
       " 'GDP_2009',\n",
       " 'GDP_2008',\n",
       " 'GDP_2007',\n",
       " 'GDP_2006',\n",
       " 'GDP_2005',\n",
       " 'CPI_2009',\n",
       " 'CATEGORIES']"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fields"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "北京\n"
     ]
    }
   ],
   "source": [
    "print(layer.GetFeature(0).GetField(\"FIRST_NAME\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "河南\n",
      "湖南\n",
      "海南\n",
      "云南\n"
     ]
    }
   ],
   "source": [
    "layer.SetAttributeFilter(\"FIRST_NAME LIKE '%南'\")\n",
    "feDict = []\n",
    "for feature in layer:\n",
    "    name = feature.GetField(\"FIRST_NAME\")\n",
    "    print(\"{0}\".format(name))\n",
    "    f = {}\n",
    "    for field in fields:\n",
    "        f[field] = feature.GetField(field)\n",
    "    geo = feature.GetGeometryRef()\n",
    "    f[\"Shape\"] = geo.ExportToWkt()\n",
    "    feDict.append(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>AREA</th>\n",
       "      <th>CATEGORIES</th>\n",
       "      <th>CPI_2009</th>\n",
       "      <th>Code</th>\n",
       "      <th>FIRST_NAME</th>\n",
       "      <th>GDP_2005</th>\n",
       "      <th>GDP_2006</th>\n",
       "      <th>GDP_2007</th>\n",
       "      <th>GDP_2008</th>\n",
       "      <th>GDP_2009</th>\n",
       "      <th>Pop_1990</th>\n",
       "      <th>Pop_1995</th>\n",
       "      <th>Pop_1999</th>\n",
       "      <th>Pop_2000</th>\n",
       "      <th>Pop_2005</th>\n",
       "      <th>Pop_2009</th>\n",
       "      <th>Pop_Birth_</th>\n",
       "      <th>Pop_Death_</th>\n",
       "      <th>Shape</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.650694e+11</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6607.0</td>\n",
       "      <td>410000</td>\n",
       "      <td>河南</td>\n",
       "      <td>10587.42</td>\n",
       "      <td>12362.79</td>\n",
       "      <td>15012.46</td>\n",
       "      <td>18018.53</td>\n",
       "      <td>19480.46</td>\n",
       "      <td>8550.9535</td>\n",
       "      <td>9100.0</td>\n",
       "      <td>9387.0</td>\n",
       "      <td>9256.0</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>9487.00</td>\n",
       "      <td>11.45</td>\n",
       "      <td>6.28</td>\n",
       "      <td>POLYGON ((114.523150095 36.174611795,114.90826...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.118197e+11</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7929.0</td>\n",
       "      <td>430000</td>\n",
       "      <td>湖南</td>\n",
       "      <td>6596.10</td>\n",
       "      <td>7688.67</td>\n",
       "      <td>9439.60</td>\n",
       "      <td>11555.00</td>\n",
       "      <td>13059.69</td>\n",
       "      <td>6065.9754</td>\n",
       "      <td>6392.0</td>\n",
       "      <td>6532.0</td>\n",
       "      <td>6440.0</td>\n",
       "      <td>6326.0</td>\n",
       "      <td>6406.00</td>\n",
       "      <td>13.05</td>\n",
       "      <td>7.15</td>\n",
       "      <td>POLYGON ((111.54824821 29.8975317250001,111.65...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.391312e+10</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6695.0</td>\n",
       "      <td>460000</td>\n",
       "      <td>海南</td>\n",
       "      <td>897.99</td>\n",
       "      <td>1044.91</td>\n",
       "      <td>1254.17</td>\n",
       "      <td>1503.06</td>\n",
       "      <td>1654.21</td>\n",
       "      <td>655.7482</td>\n",
       "      <td>724.0</td>\n",
       "      <td>762.0</td>\n",
       "      <td>787.0</td>\n",
       "      <td>828.0</td>\n",
       "      <td>864.07</td>\n",
       "      <td>14.66</td>\n",
       "      <td>5.61</td>\n",
       "      <td>POLYGON ((111.01501042 19.6430067200001,110.86...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.837339e+11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5926.0</td>\n",
       "      <td>530000</td>\n",
       "      <td>云南</td>\n",
       "      <td>3461.73</td>\n",
       "      <td>3988.14</td>\n",
       "      <td>4772.52</td>\n",
       "      <td>5692.12</td>\n",
       "      <td>6169.75</td>\n",
       "      <td>3697.2610</td>\n",
       "      <td>3990.0</td>\n",
       "      <td>4192.0</td>\n",
       "      <td>4288.0</td>\n",
       "      <td>4450.0</td>\n",
       "      <td>4571.00</td>\n",
       "      <td>12.53</td>\n",
       "      <td>8.03</td>\n",
       "      <td>POLYGON ((99.35850006 28.190228345,99.37616517...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           AREA  CATEGORIES  CPI_2009    Code FIRST_NAME  GDP_2005  GDP_2006  \\\n",
       "0  1.650694e+11         2.0    6607.0  410000         河南  10587.42  12362.79   \n",
       "1  2.118197e+11         3.0    7929.0  430000         湖南   6596.10   7688.67   \n",
       "2  3.391312e+10         3.0    6695.0  460000         海南    897.99   1044.91   \n",
       "3  3.837339e+11         4.0    5926.0  530000         云南   3461.73   3988.14   \n",
       "\n",
       "   GDP_2007  GDP_2008  GDP_2009   Pop_1990  Pop_1995  Pop_1999  Pop_2000  \\\n",
       "0  15012.46  18018.53  19480.46  8550.9535    9100.0    9387.0    9256.0   \n",
       "1   9439.60  11555.00  13059.69  6065.9754    6392.0    6532.0    6440.0   \n",
       "2   1254.17   1503.06   1654.21   655.7482     724.0     762.0     787.0   \n",
       "3   4772.52   5692.12   6169.75  3697.2610    3990.0    4192.0    4288.0   \n",
       "\n",
       "   Pop_2005  Pop_2009  Pop_Birth_  Pop_Death_  \\\n",
       "0    9380.0   9487.00       11.45        6.28   \n",
       "1    6326.0   6406.00       13.05        7.15   \n",
       "2     828.0    864.07       14.66        5.61   \n",
       "3    4450.0   4571.00       12.53        8.03   \n",
       "\n",
       "                                               Shape  \n",
       "0  POLYGON ((114.523150095 36.174611795,114.90826...  \n",
       "1  POLYGON ((111.54824821 29.8975317250001,111.65...  \n",
       "2  POLYGON ((111.01501042 19.6430067200001,110.86...  \n",
       "3  POLYGON ((99.35850006 28.190228345,99.37616517...  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(feDict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "江苏\n",
      "山东\n",
      "河南\n",
      "广东\n",
      "河北\n"
     ]
    }
   ],
   "source": [
    "layer.SetAttributeFilter(\"GDP_2005 > 10000 and Pop_2005 > 6000\")\n",
    "feDict = []\n",
    "for feature in layer:\n",
    "    name = feature.GetField(\"FIRST_NAME\")\n",
    "    print(\"{0}\".format(name))\n",
    "    f = {}\n",
    "    for field in fields:\n",
    "        f[field] = feature.GetField(field)\n",
    "    geo = feature.GetGeometryRef()\n",
    "    f[\"Shape\"] = geo.ExportToWkt()\n",
    "    feDict.append(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>AREA</th>\n",
       "      <th>CATEGORIES</th>\n",
       "      <th>CPI_2009</th>\n",
       "      <th>Code</th>\n",
       "      <th>FIRST_NAME</th>\n",
       "      <th>GDP_2005</th>\n",
       "      <th>GDP_2006</th>\n",
       "      <th>GDP_2007</th>\n",
       "      <th>GDP_2008</th>\n",
       "      <th>GDP_2009</th>\n",
       "      <th>Pop_1990</th>\n",
       "      <th>Pop_1995</th>\n",
       "      <th>Pop_1999</th>\n",
       "      <th>Pop_2000</th>\n",
       "      <th>Pop_2005</th>\n",
       "      <th>Pop_2009</th>\n",
       "      <th>Pop_Birth_</th>\n",
       "      <th>Pop_Death_</th>\n",
       "      <th>Shape</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.542384e+11</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10494.0</td>\n",
       "      <td>370000</td>\n",
       "      <td>山东</td>\n",
       "      <td>18366.87</td>\n",
       "      <td>21900.19</td>\n",
       "      <td>25776.91</td>\n",
       "      <td>30933.28</td>\n",
       "      <td>33896.65</td>\n",
       "      <td>8439.2827</td>\n",
       "      <td>8705.0</td>\n",
       "      <td>8883.0</td>\n",
       "      <td>9079.0</td>\n",
       "      <td>9248.0</td>\n",
       "      <td>9470.3</td>\n",
       "      <td>11.70</td>\n",
       "      <td>6.47</td>\n",
       "      <td>POLYGON ((122.214118076 36.907911525,122.24096...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.650694e+11</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6607.0</td>\n",
       "      <td>410000</td>\n",
       "      <td>河南</td>\n",
       "      <td>10587.42</td>\n",
       "      <td>12362.79</td>\n",
       "      <td>15012.46</td>\n",
       "      <td>18018.53</td>\n",
       "      <td>19480.46</td>\n",
       "      <td>8550.9535</td>\n",
       "      <td>9100.0</td>\n",
       "      <td>9387.0</td>\n",
       "      <td>9256.0</td>\n",
       "      <td>9380.0</td>\n",
       "      <td>9487.0</td>\n",
       "      <td>11.45</td>\n",
       "      <td>6.28</td>\n",
       "      <td>POLYGON ((114.523150095 36.174611795,114.90826...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.760488e+11</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15291.0</td>\n",
       "      <td>440000</td>\n",
       "      <td>广东</td>\n",
       "      <td>22557.37</td>\n",
       "      <td>26587.76</td>\n",
       "      <td>31777.01</td>\n",
       "      <td>36796.71</td>\n",
       "      <td>39482.56</td>\n",
       "      <td>6282.9236</td>\n",
       "      <td>6868.0</td>\n",
       "      <td>7270.0</td>\n",
       "      <td>8642.0</td>\n",
       "      <td>9194.0</td>\n",
       "      <td>9638.0</td>\n",
       "      <td>11.78</td>\n",
       "      <td>5.70</td>\n",
       "      <td>POLYGON ((114.25986752 25.2930331750001,114.39...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           AREA  CATEGORIES  CPI_2009    Code FIRST_NAME  GDP_2005  GDP_2006  \\\n",
       "0  1.542384e+11         2.0   10494.0  370000         山东  18366.87  21900.19   \n",
       "1  1.650694e+11         2.0    6607.0  410000         河南  10587.42  12362.79   \n",
       "2  1.760488e+11         3.0   15291.0  440000         广东  22557.37  26587.76   \n",
       "\n",
       "   GDP_2007  GDP_2008  GDP_2009   Pop_1990  Pop_1995  Pop_1999  Pop_2000  \\\n",
       "0  25776.91  30933.28  33896.65  8439.2827    8705.0    8883.0    9079.0   \n",
       "1  15012.46  18018.53  19480.46  8550.9535    9100.0    9387.0    9256.0   \n",
       "2  31777.01  36796.71  39482.56  6282.9236    6868.0    7270.0    8642.0   \n",
       "\n",
       "   Pop_2005  Pop_2009  Pop_Birth_  Pop_Death_  \\\n",
       "0    9248.0    9470.3       11.70        6.47   \n",
       "1    9380.0    9487.0       11.45        6.28   \n",
       "2    9194.0    9638.0       11.78        5.70   \n",
       "\n",
       "                                               Shape  \n",
       "0  POLYGON ((122.214118076 36.907911525,122.24096...  \n",
       "1  POLYGON ((114.523150095 36.174611795,114.90826...  \n",
       "2  POLYGON ((114.25986752 25.2930331750001,114.39...  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(feDict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
